package com.facebank.usersupport.mapper.usersupport.usersupport;

import com.facebank.usersupport.dto.ActivityDto;
import com.facebank.usersupport.model.Activity;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;
@Repository
public interface ActivityMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Activity record);

    int insertSelective(Activity record);

    Activity selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Activity record);

    int updateByPrimaryKey(Activity record);

    List<Activity> selectRouteList(@Param("routeName") String routeName, @Param("routeType")Short routeType,@Param("status") Short status, @Param("startTime")Long startTime,@Param("endTime") Long endTime);

    int activityCount(@Param("startTime") Long startTime,@Param("endTime")Long endTime,@Param("monthNo")Integer monthNo,@Param("routeType")Short routeType);

    List<Activity> selectActivityByTypeId(Short typeId);

    List<Activity> selectActivityList();

    List<Activity> selectRandActivityList();
}